Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ConsumerrConversionStateID (PK) | Token ID for a PartyConversionState instance. | ID_CT_CVN_ST | Identity | integer | |
EffectiveDateTime | Date and time the consumer conversion state becomes effective. This represents the start point of a given consumer-state tenure. | DT_EF | EffectiveDateTime | datetime | |
ExpirationDateTime | Date and time the consumer conversion state exires. This represents the endt point of a given consumer-state tenure. | DT_EP | ExpirationDateTime | datetime | |
CurrentStatus | Indicates if this is the currently active STATE of a Party - ConversionState association. Note that only ONE association may be active at any point in time. | CD_STS | Code2Status | char(2) | |
ConversionStateCode (FK) | A code used to designate the conversion status or condition of a party. (See ConversionState ET definition) | CD_CVN_ST | Code | varchar(20) | ConversionState(CO_CVN_ST) |
ConversionEventID (FK) | A token ID for a ConversionEvent | ID_CVN_EV | Identity | integer | ConversionEvent(CO_CVN_EV) |
ConsumerID (FK) | Token ID for a Consumer instance. | ID_CNS | Identity | integer | Consumer(PA_CNS) |
ChannelID (FK) | Token Identifier for a channel instance | ID_CHNL | Identity | integer | ConversionEvent(CO_CVN_EV) |